package com.atguigu.tingshu.album.mapper;

import com.atguigu.tingshu.model.album.TrackInfo;
import com.atguigu.tingshu.query.album.TrackInfoQuery;
import com.atguigu.tingshu.vo.album.AlbumTrackListVo;
import com.atguigu.tingshu.vo.album.TrackListVo;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface TrackInfoMapper extends BaseMapper<TrackInfo> {

    /*
     * 获取当前用户全部专辑列表
     * */
    IPage<TrackListVo> selectTrackList(Page<TrackListVo> trackListVoPage,@Param("vo") TrackInfoQuery trackInfoQuery);


    @Update("update track_info set order_num = order_num - 1 where order_num > #{orderNum} and album_id = #{albumId} and is_deleted = 0")
    void updateOrderNum(@Param("orderNum") Integer orderNum, @Param("albumId") Long albumId);

    /*
    * 根据专辑id获取声音分页列表
    * */
@Select("select\n" +
        "    track.id track_id,\n" +
        "    track.album_id,\n" +
        "    track.track_title,\n" +
        "    track.media_duration,\n" +
        "    track.order_num,\n" +
        "    track.create_time,\n" +
        "    max(if(stat.stat_type='0701',stat.stat_num,0)) playStatNum,\n" +
        "    max(if(stat.stat_type='0704',stat.stat_num,0)) commentStatNum\n" +
        "from track_info track inner join track_stat stat on track.id = stat.track_id\n" +
        " where track.album_id=1 and track.is_open='1' and track.is_deleted=0 and track.status='0501'\n" +
        "group by track.id")
IPage<AlbumTrackListVo> getTrackInfoList(Page<AlbumTrackListVo> trackListVoPage, @Param("albumId") Long albumId);
}
